SET NOCOUNT ON
SET QUOTED_IDENTIFIER ON
GO

PRINT '---- USERS AND ROLES'

--------- Create Users-----------------
INSERT tblUFGUsers (usr_UserName,usr_Password,usr_PasswordSalt)
VALUES ('Bond',HASHBYTES('sha1','Bond'),'')
INSERT tblUFGUsers (usr_UserName,usr_Password,usr_PasswordSalt)
VALUES ('Club',HASHBYTES('sha1','Club'),'')
INSERT tblUFGUsers (usr_UserName,usr_Password,usr_PasswordSalt)
VALUES ('Lid',HASHBYTES('sha1','Lid'),'')

UPDATE tblPersons
SET prs_Username = 'Lid'
WHERE prs_ID = 3

UPDATE tblPersons
SET prs_Username = 'Club'
WHERE prs_ID = 4
-------- Create Roles-----------------

------club---------------
INSERT tblUFGRoles (urr_RoleName,urr_StyleSheet)
VALUES ('Voorzitter Club','IMAGineBlue')
INSERT tblUFGRoles (urr_RoleName,urr_StyleSheet)
VALUES ('Ledenadministratie Club','IMAGineBlue')
INSERT tblUFGRoles (urr_RoleName,urr_StyleSheet)
VALUES ('Wedstrijdsecretariaat Club','IMAGineBlue')
INSERT tblUFGRoles (urr_RoleName,urr_StyleSheet)
VALUES ('Technische Commissie Club','IMAGineBlue')
INSERT tblUFGRoles (urr_RoleName,urr_StyleSheet)
VALUES ('Scheidsrechterscommissie Club','IMAGineBlue')

-------Bond-------------------
INSERT tblUFGRoles (urr_Rolename,urr_StyleSheet) 
VALUES ('Ledenadministratie Bond','IMAGineBlue')
INSERT tblUFGRoles (urr_Rolename,urr_StyleSheet) 
VALUES ('Scheidsrechterscommissie Bond','IMAGineBlue')
INSERT tblUFGRoles (urr_Rolename,urr_StyleSheet) 
VALUES ('Wedstrijdsecretariaat Bond','IMAGineBlue')
INSERT tblUFGRoles (urr_Rolename,urr_StyleSheet) 
VALUES ('Tuchtcommissie Bond','IMAGineBlue')

------------Leden---------------
INSERT tblUFGRoles (urr_Rolename,urr_StyleSheet) 
VALUES ('Leden','IMAGineBlue')

-------- Users in Roles-----------------
------club---------------
INSERT tblUFGUsersInRoles (uir_UserName,uir_RoleName)
VALUES ('Club','Voorzitter Club')
INSERT tblUFGUsersInRoles (uir_UserName,uir_RoleName)
VALUES ('Club','Ledenadministratie Club')
INSERT tblUFGUsersInRoles (uir_UserName,uir_RoleName)
VALUES ('Club','Wedstrijdsecretariaat Club')
INSERT tblUFGUsersInRoles (uir_UserName,uir_RoleName)
VALUES ('Club','Technische Commissie Club')
INSERT tblUFGUsersInRoles (uir_UserName,uir_RoleName)
VALUES ('Club','Scheidsrechterscommissie Club')
INSERT tblUFGUsersInRoles (uir_UserName,uir_RoleName)
VALUES ('Club','Leden')

-------Bond-------------------
INSERT tblUFGUsersInRoles (uir_UserName,uir_RoleName)
VALUES ('Bond','Ledenadministratie Bond')
INSERT tblUFGUsersInRoles (uir_UserName,uir_RoleName)
VALUES ('Bond','Scheidsrechterscommissie Bond')
INSERT tblUFGUsersInRoles (uir_UserName,uir_RoleName)
VALUES ('Bond','Wedstrijdsecretariaat Bond')
INSERT tblUFGUsersInRoles (uir_UserName,uir_RoleName)
VALUES ('Bond','Tuchtcommissie Bond')
INSERT tblUFGUsersInRoles (uir_UserName,uir_RoleName)
VALUES ('Bond','Leden')

-------Leden-------------------
INSERT tblUFGUsersInRoles (uir_UserName,uir_RoleName)
VALUES ('Lid','Leden')